A Convenient Way From Normalized Database To Denormalized Database

Data warehouse is a denormalized and information oriented system used to convert business rules into useful information as it is the collection of archived operational data which is useful in tactical and strategic business decisions. A relational database consists of a collection of tables that store particular sets of data in a form of normalized database. We use ER Model in relational database to define our overall system on the other hand in data warehouse we use dimensional cubes. In this paper we will discuss the techniques to transform the relational database into data warehouse. Here, we will concentrate on dimensional model as it heavily aggregated on business dimensions to improve retrieval performance rather than optimization of update performance as in the Entity Relationship model in relational database. The method for construction of data warehouse using dimensional model is presented which uses related data of operational system as its base for identifying important objects. We identify relationship between the objects that is different categories of objects. Data warehouse is designed to support ad hoc queries and strategic decision analysis which is not possible with traditional operational systems in which we require multiple tables join that is a huge web of joins using which strategic business decision making is not possible so here we introduced a technique which transforms already existing system into useful information retrieval system used to make tricky and tactical business decisions.